/**
 * Software License, Version 1.0
 * 
 * Copyright 2003 The Trustees of Indiana University.  All rights reserved.
 * 
 *
 *Redistribution and use in source and binary forms, with or without 
 *modification, are permitted provided that the following conditions are met:
 *
 *1) All redistributions of source code must retain the above copyright notice,
 * the list of authors in the original source code, this list of conditions and
 * the disclaimer listed in this license;
 *2) All redistributions in binary form must reproduce the above copyright 
 * notice, this list of conditions and the disclaimer listed in this license in
 * the documentation and/or other materials provided with the distribution;
 *3) Any documentation included with all redistributions must include the 
 * following acknowledgement:
 *
 *"This product includes software developed by the Community Grids Lab. For 
 * further information contact the Community Grids Lab at 
 * http://communitygrids.iu.edu/."
 *
 * Alternatively, this acknowledgement may appear in the software itself, and 
 * wherever such third-party acknowledgments normally appear.
 * 
 *4) The name Indiana University or Community Grids Lab or NaradaBrokering, 
 * shall not be used to endorse or promote products derived from this software 
 * without prior written permission from Indiana University.  For written 
 * permission, please contact the Advanced Research and Technology Institute 
 * ("ARTI") at 351 West 10th Street, Indianapolis, Indiana 46202.
 *5) Products derived from this software may not be called NaradaBrokering, 
 * nor may Indiana University or Community Grids Lab or NaradaBrokering appear
 * in their name, without prior written permission of ARTI.
 * 
 *
 * Indiana University provides no reassurances that the source code provided 
 * does not infringe the patent or any other intellectual property rights of 
 * any other entity.  Indiana University disclaims any liability to any 
 * recipient for claims brought by any other entity based on infringement of 
 * intellectual property rights or otherwise.  
 *
 *LICENSEE UNDERSTANDS THAT SOFTWARE IS PROVIDED "AS IS" FOR WHICH NO 
 *WARRANTIES AS TO CAPABILITIES OR ACCURACY ARE MADE. INDIANA UNIVERSITY GIVES
 *NO WARRANTIES AND MAKES NO REPRESENTATION THAT SOFTWARE IS FREE OF 
 *INFRINGEMENT OF THIRD PARTY PATENT, COPYRIGHT, OR OTHER PROPRIETARY RIGHTS. 
 *INDIANA UNIVERSITY MAKES NO WARRANTIES THAT SOFTWARE IS FREE FROM "BUGS", 
 *"VIRUSES", "TROJAN HORSES", "TRAP DOORS", "WORMS", OR OTHER HARMFUL CODE.  
 *LICENSEE ASSUMES THE ENTIRE RISK AS TO THE PERFORMANCE OF SOFTWARE AND/OR 
 *ASSOCIATED MATERIALS, AND TO THE PERFORMANCE AND VALIDITY OF INFORMATION 
 *GENERATED USING SOFTWARE.
 */
/**
 * Software License, Version 1.0
 *
 * Copyright 2003 The Trustees of Indiana University.  All rights reserved.
 *
 *
 *Redistribution and use in source and binary forms, with or without
 *modification, are permitted provided that the following conditions are met:
 *
 *1) All redistributions of source code must retain the above copyright notice,
 * the list of authors in the original source code, this list of conditions and
 * the disclaimer listed in this license;
 *2) All redistributions in binary form must reproduce the above copyright
 * notice, this list of conditions and the disclaimer listed in this license in
 * the documentation and/or other materials provided with the distribution;
 *3) Any documentation included with all redistributions must include the
 * following acknowledgement:
 *
 *"This product includes software developed by the Community Grids Lab. For
 * further information contact the Community Grids Lab at
 * http://communitygrids.iu.edu/."
 *
 * Alternatively, this acknowledgement may appear in the software itself, and
 * wherever such third-party acknowledgments normally appear.
 *
 *4) The name Indiana University or Community Grids Lab or NaradaBrokering,
 * shall not be used to endorse or promote products derived from this software
 * without prior written permission from Indiana University.  For written
 * permission, please contact the Advanced Research and Technology Institute
 * ("ARTI") at 351 West 10th Street, Indianapolis, Indiana 46202.
 *5) Products derived from this software may not be called NaradaBrokering,
 * nor may Indiana University or Community Grids Lab or NaradaBrokering appear
 * in their name, without prior written permission of ARTI.
 *
 *
 * Indiana University provides no reassurances that the source code provided
 * does not infringe the patent or any other intellectual property rights of
 * any other entity.  Indiana University disclaims any liability to any
 * recipient for claims brought by any other entity based on infringement of
 * intellectual property rights or otherwise.
 *
 *LICENSEE UNDERSTANDS THAT SOFTWARE IS PROVIDED "AS IS" FOR WHICH NO
 *WARRANTIES AS TO CAPABILITIES OR ACCURACY ARE MADE. INDIANA UNIVERSITY GIVES
 *NO WARRANTIES AND MAKES NO REPRESENTATION THAT SOFTWARE IS FREE OF
 *INFRINGEMENT OF THIRD PARTY PATENT, COPYRIGHT, OR OTHER PROPRIETARY RIGHTS.
 *INDIANA UNIVERSITY MAKES NO WARRANTIES THAT SOFTWARE IS FREE FROM "BUGS",
 *"VIRUSES", "TROJAN HORSES", "TRAP DOORS", "WORMS", OR OTHER HARMFUL CODE.
 *LICENSEE ASSUMES THE ENTIRE RISK AS TO THE PERFORMANCE OF SOFTWARE AND/OR
 *ASSOCIATED MATERIALS, AND TO THE PERFORMANCE AND VALIDITY OF INFORMATION
 *GENERATED USING SOFTWARE.
 */
package cgl.narada.gui.admin.reliable.viewtable;

import javax.swing.JLabel;

import cgl.narada.gui.admin.reliable.UserConfigure;
import cgl.narada.matching.Profile;
import cgl.narada.service.storage.StorageService;
import cgl.narada.service.storage.StorageServiceFactory;
import cgl.narada.service.storage.db.DataAccessObject;
import cgl.narada.service.storage.db.DatabaseFactory;

public class ProfileNbTableModel
    extends NbTableModel {

  public ProfileNbTableModel() {
    columnData = new ColumnData[5];
    columnData[0] = new ColumnData("Profile ID", 200, JLabel.LEFT);
    columnData[1] = new ColumnData("Subscription", 200, JLabel.LEFT);
    columnData[2] = new ColumnData("Profile Type", 200, JLabel.LEFT);
    columnData[3] = new ColumnData("Template ID", 200, JLabel.LEFT);
    columnData[4] = new ColumnData("EntityID", 200, JLabel.LEFT);

  }

  public Object getValueAt(int rowNum, int columnNum) {
    if (rowNum < 0 || rowNum >= getRowCount()) {
      return "";
    }
    ProfileRowData row = (ProfileRowData) allRow.elementAt(rowNum);
    switch (columnNum) {
      case 0:
        return row.profileID;
      case 1:
        return row.subscription;
      case 2:
        return row.profileType;
      case 3:
        return row.templateID;
      case 4:
        return row.entityID;
    }
    return "";
  }

  /*
    public void setDefaultData(){
      allRow.removeAllElements();
       allRow.addElement(new ProfileRowData("1","recovery event", "bytes","1","1"));
    }
   */

  public void setDefaultData() {
    allRow.removeAllElements();
    try {
      if (impl.equals("db")) {
        //DataAccessObject dao = new DataAccessObject();
        DataAccessObject dao = null;

        DatabaseFactory df = new DatabaseFactory();
        try {
          dao = df.getDAO();
        }
        catch (Exception ex) {
          System.out.println("exception in creating DataAccessObject ");
        }
        
//        StorageServiceDbImpl ssDbImpl = new StorageServiceDbImpl();
        StorageService ssDbImpl = StorageServiceFactory.getStorageService(
            "db", UserConfigure.getProperties());
        
        String searchQueryProfile =
            "select templateId from Profile group by templateId;";
        java.sql.ResultSet rs = dao.executePreparedQuery(searchQueryProfile);
        while (rs.next()) {
          int templateId = rs.getInt(1);
          Profile[] profiles = ssDbImpl.getListOfRegisteredProfiles(templateId);
          for (int i = 0; i < profiles.length; i++) {
            Profile oneProfile = profiles[i];
            allRow.add(new ProfileRowData(oneProfile.getProfileId(),
                                          oneProfile.getSubscription().toString(),
                                          oneProfile.getProfileType() + "",
                                          "" + templateId,
                                          oneProfile.getDestination() + ""));
          }
        }

      }
      else if (impl.equals("file")) {
        new FileStorageGuiHelp().fetchProfile(allRow);
      }
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

}